Enhance your SQL query writing skills to provide greater business value using advanced techniques such as common table expressions, window functions, and JSON Purchase of the print or Kindle book includes a free PDF eBookKey FeaturesExamine query design and performance using query plans and indexesSolve business problems using advanced techniques such as common table expressions and window functionsUse SQL in modern data platform solutions with...

This book examines the intricate and under-explored dynamics of ethnic politics in post-socialist states and their implications for China. While focusing on the political, cultural, and ethnic landscapes of Central Asia and their connections to China, the volume highlights how shared historical legacies and emerging geopolitical realities shape ethnic policies and state relations. Contributions from scholars based in the UK, Kazakhstan, and China provide a comprehensive analysis of key iss...

This book focuses on tea-ware design exchanges between China and the UK since the middle of 17th Century, and explores how design encouraged trade and how the market demand influenced the development of design. The spirit of Chinese tea came to Britain alone with tea itself, and enriched the design of tea-ware, as well as British tea culture. During this process, tea-related oriental aesthetics evolved into an aesthetic image mechanism and developed as aesthetic concept, which infiltrated ...

Comprehensive resource on the fundamentals, recent research developments, and applications of triboelectric nanogenerators (TENGs)Triboelectric Nanogenerators delivers a comprehensive overview of a lightweight, low cost, and high-efficiency sustainable mechanical energy harvesting technique that draws from the ambient environment and has high output and extremely flexible structural designs.The book starts with an introduction on triboelectric nano...

This edited volume examines the crucial, yet overlooked, role narratives play in the rapidly changing relationship between Europe and China.Its contributors analyse the role of narratives in different societies and arenas ranging from economic and foreign policy to history and social media. Emphasizing the social dimension of narrative, the volume challenges traditional state-centric and strategic approaches in international politics. It also engages with the ubiquity of stories ab...

This book brings together scholars based in, or had previously been based in a range of East and Southeast Asian countries, building on their respective primary empirical data and first-hand experience as academics and think tank researchers, in order to pluralise the current debates about governance in transitional societies. In an era of global democratic backsliding, this edited volume offers less-explored local perspectives, to balance the Western-centrism observed in area studies and ...

This book explores the emergent concept of 'human security' within the political context of COVID-19 Chinese politics. For decades, Western nations have used 'human rights' as a rubric with which to scold Chinese leaders, betraying a fundamental unwillingness to accept diversity of governance systems. As COVID-19 has demonstrated, different governance systems yield different outcomes—the freedom of circulation, speech and movement in Western democracies yielding one, and use of surveillanc...

This book examines how the Chinese Communist Party (CCP) has sought to legitimise its counter-terrorism strategy in the eyes of its domestic and international audiences. An important element of CCP policy in Xinjiang has been the deployment of ordinary Chinese citizens, or the 'mass line,’ to create new realities on the ground. This book explores how the history of ideological struggle in the PRC has taken on new characteristics, as well as offering insight into how the CCP has maintained ...

This monograph aims to provide an in-depth analysis of the legal protection of the private equity (PE) investors in China. In an academic sense, this research mainly focuses on the agency problems in the life cycle of PE investment under the business organization law system in China. Briefly speaking, the agency problems of PE investment derive from the two-level separation of ownership and control, one of which is the principal–agent relationship between the PE investors and the fund mana...

This book provides a series of systematic theoretical results and numerical solution algorithms for dynamic optimization problems of switched systems within infinite-dimensional inequality path constraints. Dynamic optimization of path-constrained switched systems is a challenging task due to the complexity from seeking the best combinatorial optimization among the system input, switch times and switching sequences. Meanwhile, to ensure safety and guarantee product quality, path constraint...

Since the beginning of the 21st century, China's energy diplomacy has been expanding rapidly and the country is searching for energy resources worldwide. This movement has not only improved China's energy security and international relations, but also enabled the Chinese national oil companies (NOCs) to access new investment markets and implement development strategies. The Chinese government and the NOCs need each other's support to realise their respective interests. The interaction betw...

Nowhere in the world is China's rapid rise to power more evident than in Africa. From multi-billion dollar investments in oil and minerals to the influx of thousands of merchants, labourers and cheap consumer goods, China's economic and political reach is redefining Africa's traditional ties with the international community. This book investigates the emerging relationship between China and Africa to determine whether this engagement will be that of a development partner, economic competit...