To address the rapidly increasing demand for advanced communication services, spectrum sharing technologies have become essential in mitigating the limited availability of radio spectrum resources. Understanding and modeling spectrum activity across various frequency ranges, times, locations, and altitudes are critical for realizing these technologies effectively. In this paper, we first present a comparative survey of the existing works on spectrum activity measurements in sub-6 GHz bands, including locations, frequency ranges, measurement times/durations, and various other characteristics of the datasets. Subsequently, we focus on a comparative analysis of altitudedependent spectrum activity in sub-6 GHz bands based on our measurement campaigns between 2022 and 2024. To do the measurements, we use an aerial platform equipped with a software-defined radio (SDR) that flies up to an altitude of 300 m in urban and rural areas of Raleigh, NC, USA. Based on the collected data, we analyze the spectrum occupancy characteristics and trends of long-term evolution (LTE) and fifth generation (5G) new radio (NR) cellular networks, as well as the industrial, scientific, and medical (ISM) bands in the United States. To better understand altitude effects, we examine the measurements in the frequency modulation (FM) radio band as a case study and propose an altitude-dependent analytical path loss model to characterize the spectrum measurements. Our observations from four dominant FM radio stations in Raleigh indicate that the received signal power gradually increases with altitude up to a critical threshold. Beyond this threshold, the signal power plateaus despite further increases in the aerial platform's altitude, attributed to enhanced line-of-sight conditions and the accumulation of signal sources in the urban environment. These findings highlight the importance of incorporating altitude as an additional dimension in spectrum usage analysis, which can significantly enhance the effectiveness of spectrum sharing strategies in the future.